Hi,

We're in transition again and I need to establish replication as above.  Got my Distributor set up and Publication.  When I try to add the subscription I get an error saying

"Failed to connect to server ""   "

"The SQL Server version (10..0) is not suppored"

Thought it was supported... is there some special configuration to get this to run?

Thanks for any/all help.

Tom

What edition of sql server are you using on sql server 2008 ? Didyou used Upgrqade advisor ?

Please check this .. https://msdn.microsoft.com/en-us/library/ms143393.aspx

TY Jinu,

I have v 10.0.1600.22

Tom

It is not clear to me where you are getting this error. If it is in management studio while trying to connect to the SQL 2008 server, use the Management Studio from the SQL 2008  server to connect to the SQL 2005 server and then create your subscription.

I assume your distribution is on SQL2005? Generally its better to make your distribution server the newest version but it should work either way.

Just like Hilary mentioned, whenever configuring the replication topology between different versions of SQL servers use the newest tools to make your configurations. If you use SQL 2005 tools while trying to add SQL2008 subscriber you would get an error when selecting a subscription server ( connect dialog box) during Add Subscription Wizard. 

However wizzard would complete successfully if you use SQL2008 SSMS connected to your SQL2005 server.

Hope this helps